<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<sql-query name="EndPoint.ListEndPointCategoryHierachically">
	CALL ListEndPointCategoryHierachically(:StartLikeHierachicalLabel);
	</sql-query>
	<sql-query name="EndPoint.DeleteEndPointCategory">
	CALL DeleteEndPointCategory(:categoryId);
	</sql-query>
	<sql-query name="EndPoint.UpdateUsable">
	UPDATE
		end_point
	SET
		Usable = b'0'
	WHERE
		EndPointId IN (:endPointsId)
	</sql-query>
</hibernate-mapping>
